Nowadays, more and more work needs to use the time zone concepts around the world. Recently, I have seen abbreviations such as DST, EDT, PDT, wet, and CCT in my documents, which makes me dizzy. So I made a memo on the Internet:
The time zone
1. Sqlloader Control File Basic format:OPTIONS (errors=1000)LOAD DATAINFILE ' T.DAT '//Data file to import (format 1)INFILE ' TT. DAT '//import multiple files (can be used in parallel with format 1)INFILE *//the content to be imported is in the
Here is the simplest test with Excel data.
1 Save Excel data as T.txt file, note file suffix named. txt
1 jhchen 11/07/2005 20:04:00 2005-11-7 20:04
2 jhchen 11/07/2005 20:04:00 2005-11-7 20:04
3 Jhchen 11/07/2005 20:04:00 2005-11-7 20:04
2)Sql>
In order to facilitate the use of the reprinted article: http://www.oracle.com.cn/viewthread.php? Tid = 13979 & extra = & page = 1sql Load
Sqlldr userid = lgone/tiger control = A. CTL
Load data
Infile't. dat // file to be imported
// Infile 'tt.
Here we use excel Data for the simplest test.
1) Save the excel data as a t.txt file. Note that the file suffix is. txt.
1 jhchen 11/07/2005 20:04:00 2005-11-7 20:04
2 jhchen 11/07/2005 20:04:00 2005-11-7 20:04
3 jhchen 11/07/2005 20:04:00 2005-11-
1. Sqlloader Control File//********************************************************************************//Basic format:LOAD DATAINFILE ' T.DAT '//Data file to import (format 1)INFILE ' TT. DAT '//import multiple files (can be used in parallel
1. Some methods for importing and exporting bulk dataSQL Server provides a variety of tools for data import and export of various data sources, including this document, ODBC data sources, OLE DB data sources, ASCII text files, and Excel spreadsheets.
This article is published in the well-known technical blog "Highly Scalable Blog", by @juliashine for translation contributions. Thanks for the translator's shared spirit.
The translator introduces: Juliashine is the year grasps the child engineer,
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.